SSIS Designer(Visual Studio 2005) cannot open package: Exception from HRESULT: 0x8007007E (System.Windows.Forms)

Categories: Database; Tagged with: BIDS • DTSX • ETL • SQL Server • SSIS • Visual Studio; @ December 8th, 2012 17:31

I try to apply SQL Server 2005 in my PC(Win 7 64bits), failed, After that, when I try to open SSIS package in BIDS, I got this Error every time:

TITLE: Microsoft Visual Studio

——————————
An error prevented the view from loading.
——————————
ADDITIONAL INFORMATION:
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms)

—————————— BUTTONS: OK ——————————

It’s kind of ridiculous. because I need to finish my DTSx package design, so I re-install SQL Server sp1. but seems no change.

Then I got this link:

2008 SSIS Designer stops working after installing VS11 Dev Preview

the chosen answer seems not for me, and I got the solution from one of the reply:

I solved the problem by deleting the whole folder “C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8“, and copying it from a machine that was working. Not the smoothest solution, I know, but it did work!

Gorgeous!

Get DTSx/SSIS Connections From C# <-> 在SSIS/DTSx中使用事务管理 Using Transaction in SSIS DTSx package